﻿Namespace SchoolClick.Database.DAL
    Public Class SchoolClickDAL
        Public Shared Function GetDepartamentos() As IEnumerable(Of SelectListItem)
            Return New SelectListItem() {New SelectListItem With {.Value = 1, .Text = "Ahuachapán"},
                                         New SelectListItem With {.Value = 2, .Text = "Cabañas"},
                                         New SelectListItem With {.Value = 3, .Text = "Chalatenango"},
                                         New SelectListItem With {.Value = 4, .Text = "Cuscatlán"},
                                         New SelectListItem With {.Value = 5, .Text = "La Libertad"},
                                         New SelectListItem With {.Value = 6, .Text = "La Paz"},
                                         New SelectListItem With {.Value = 7, .Text = "La Unión"},
                                         New SelectListItem With {.Value = 8, .Text = "Morazán"},
                                         New SelectListItem With {.Value = 9, .Text = "San Miguel"},
                                         New SelectListItem With {.Value = 10, .Text = "San Salvador"},
                                         New SelectListItem With {.Value = 11, .Text = "San Vicente"},
                                         New SelectListItem With {.Value = 12, .Text = "Santa Ana"},
                                         New SelectListItem With {.Value = 13, .Text = "Sonsonate"},
                                         New SelectListItem With {.Value = 14, .Text = "Usulután"}}
        End Function

        Public Shared Function GetSiAndNo() As IEnumerable(Of SelectListItem)
            Return New SelectListItem() {New SelectListItem With {.Text = "Si", .Value = True, .Selected = True},
                                         New SelectListItem With {.Text = "No", .Value = False}}
        End Function

        Public Shared Function GetNoAndSi() As IEnumerable(Of SelectListItem)
            Return New SelectListItem() {New SelectListItem With {.Text = "Si", .Value = True},
                                         New SelectListItem With {.Text = "No", .Value = False, .Selected = True}}
        End Function

        Public Shared Function GetGeneros() As IEnumerable(Of SelectListItem)
            Return New SelectListItem() {New SelectListItem With {.Text = "Masculino", .Value = "M"},
                                         New SelectListItem With {.Text = "Femenino", .Value = "F"}}
        End Function

        Public Shared Function GetUbicacionGeo() As IEnumerable(Of SelectListItem)
            Return New SelectListItem() {New SelectListItem With {.Text = "Urbana", .Value = "U"},
                                         New SelectListItem With {.Text = "Rural", .Value = "R"}}
        End Function

        Public Shared Function GetParentesco() As IEnumerable(Of SelectListItem)
            Dim lst As SelectListItem() = {New SelectListItem With {.Text = "Abuelo", .Value = "AM"},
                                         New SelectListItem With {.Text = "Abuela", .Value = "AF"},
                                         New SelectListItem With {.Text = "Primo", .Value = "PM"},
                                         New SelectListItem With {.Text = "Prima", .Value = "PF"},
                                         New SelectListItem With {.Text = "Hermano", .Value = "HM"},
                                         New SelectListItem With {.Text = "Hermana", .Value = "HF"},
                                         New SelectListItem With {.Text = "Tio", .Value = "TM"},
                                         New SelectListItem With {.Text = "Tia", .Value = "TF"},
                                         New SelectListItem With {.Text = "Otro", .Value = "OT"}}

            Return lst.OrderBy(Function(p) p.Text)
        End Function

        Public Shared Function GetViveCon() As IEnumerable(Of SelectListItem)
            Dim lst As SelectListItem() = {New SelectListItem With {.Text = "Solo con mi madre", .Value = "SM"},
                                         New SelectListItem With {.Text = "Solo con mi padre", .Value = "SP"},
                                         New SelectListItem With {.Text = "Ambos (Padre y Madre)", .Value = "AM"},
                                         New SelectListItem With {.Text = "Familiares", .Value = "CF"},
                                         New SelectListItem With {.Text = "No vivo con familiares", .Value = "SF"}}
            Return lst.OrderBy(Function(p) p.Text)
        End Function

        Public Shared Function GetShowHide() As IEnumerable(Of SelectListItem)
            Return New SelectListItem() {New SelectListItem With {.Text = "Mostrar", .Value = "True"},
                                         New SelectListItem With {.Text = "Ocultar", .Value = "False", .Selected = True}}
        End Function

        Public Shared Function GetMetodosAsignacion() As IEnumerable(Of SelectListItem)
            Return New SelectListItem() {New SelectListItem With {.Text = "Asignar al azar los de nuevo ingreso y mantener la sección de los de antiguo ingreso.", .Value = "1"}}
        End Function

        Public Shared Function GetGradosPromocion() As IEnumerable(Of SelectListItem)
            Return New SelectListItem() {New SelectListItem With {.Text = "2 Año de Bachillerato General", .Value = "2-General"},
                                         New SelectListItem With {.Text = "3 Año de Bachillerato Técnico Vocacional Comercial Opción Contaduría", .Value = "3-Ciencias Economicas"}}
        End Function
    End Class
End Namespace
